{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Part of this file can't be rendered in GitHub. Refer to the following link for a properly rendered version of this file: https://nbviewer.jupyter.org/github/sfu-db/dataprep/blob/develop/examples/DataConnector_Finnhub.ipynb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Connector for Finnhub \n",
    "\n",
    "In this example, we will be going over how to use Connector with Finnhub."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Prerequisites\n",
    "\n",
    "Connector is a component in the DataPrep library that aims to simplify data access by providing a standard API set. The goal is to help users skip the complex API configuration. In this tutorial, we demonstrate how to use the connector component with Finnhub.\n",
    "\n",
    "If you haven't installed DataPrep, run command `!pip install dataprep` or execute the following cell."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Run me if you'd like to install\n",
    "!pip install dataprep"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Download and store the configuration files in DataPrep. \n",
    "\n",
    "The configuration files are used to configure the parameters and initial setup for the API. The available configuration files can be manually downloaded here: [Configuration Files](https://github.com/sfu-db/DataConnectorConfigs) or automatically downloaded at usage. \n",
    "\n",
    "Store the configuration file in the dataprep folder. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Obtaining access token from Finnhub\n",
    "\n",
    "1. In order for the Finnhub API to work, you need to create an account on the website to get an API key. Create an account [here](https://finnhub.io/register) with your email address. \n",
    "\n",
    "\n",
    "2. Upon registering yourself on Finnhub, you will be redirected automatically to the [Finnhub Dashboard](https://finnhub.io/dashboard) where you can view your API key. This API key will be used to access data from Finnhub using Connector."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Initialize connector\n",
    "\n",
    "Copy and paste your API key as the value for the **auth_token** variable. Ensure the **API name** argument is correct. This establishes a connection with Twitter and returns an object. Once you run the code you can use the built in functions available from connector."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from dataprep.connector import connect, info\n",
    "\n",
    "auth_token = '<insert API key>'\n",
    "dc = connect('finnhub', _auth={\"access_token\":auth_token})\n",
    "\n",
    "dc"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Functionalities\n",
    "\n",
    "Connector has several functions you can perform to gain insight on the data downloaded from Finnhub.\n",
    "\n",
    "### Connector.info\n",
    "The info method gives information and guidelines on using the connector. There are 4 sections in the response and they are table, parameters, example and schema.\n",
    "\n",
    ">1. Table - The table(s) being accessed.\n",
    ">2. Parameters - Identifies which parameters can be used to call the method.\n",
    ">3. Examples - Shows how you can call the methods in the Connector class.\n",
    ">4. Schema - Names and data types of attributes in the response."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<html>\n",
       "    <head>\n",
       "        <title> DataPrep.Connector Info </title>\n",
       "        <script>\n",
       "            function switchTab637(e) {\n",
       "                const selectedAreaSuffix = e.parentElement.parentElement.className.split('-')[1];\n",
       "                const selectedTabId = e.id.split('-')[2];\n",
       "                const selectedTabContent = document.querySelector(`.contents-${selectedAreaSuffix}>div:nth-of-type(${selectedTabId})`);\n",
       "                const contentArray = document.getElementsByClassName('info-637')\n",
       "                for (let i of contentArray) {\n",
       "                    i.style.display = 'none';\n",
       "                }\n",
       "                selectedTabContent.style.display = 'block';\n",
       "            }\n",
       "        </script>\n",
       "        <style>\n",
       "            .container-637 {\n",
       "            }\n",
       "            .container-637 input[type=radio] {\n",
       "            display: none;\n",
       "            }\n",
       "            .tabs-637 {\n",
       "            font-family: -apple-system, 'Helvetica Neue', 'Helvetica', 'Arial', 'Lucida Grande', sans-serif;\n",
       "            -webkit-font-smoothing: antialiased;\n",
       "            display: grid;\n",
       "            flex-wrap: wrap;\n",
       "            gap: 5px;\n",
       "            grid-template-columns: repeat(auto-fill, minmax(110px, 1fr));\n",
       "            justify-content: wrap;\n",
       "            }\n",
       "            .tabs-637 label {\n",
       "            word-wrap: break-word;\n",
       "            text-align: center;\n",
       "            font-size: 12px;\n",
       "            border-bottom: 2px solid #9edae5;\n",
       "            transition: border 0.3s ease;\n",
       "            }\n",
       "            .tabs-637 label:hover {\n",
       "            background: rgba(0, 0, 0, 0.1);\n",
       "            }\n",
       "            .tabs-637 input:checked+label {\n",
       "            border-bottom: 2px solid #1f77b4;\n",
       "            }\n",
       "            .contents-637>div:nth-of-type(n+2) {\n",
       "            display: none;\n",
       "            }\n",
       "            h4 {\n",
       "            font-size: 14px;\n",
       "            font-family: Arial;\n",
       "            }\n",
       "            p {\n",
       "            font-size: 13px;\n",
       "            }\n",
       "        </style>\n",
       "    </head>\n",
       "    <body>\n",
       "        <div class=\"container-637\">\n",
       "            <div class=\"tabs-637\">\n",
       "                <input type=\"radio\" name=\"select\" id='tab-637-1' checked onclick=\"switchTab637(this)\">\n",
       "                <label for=\"tab-637-1\">company_news</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-2  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-2>countries</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-3  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-3>covid19</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-4  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-4>earnings</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-5  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-5>earnings_calender</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-6  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-6>economic_calender</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-7  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-7>filings</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-8  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-8>general_news</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-9  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-9>ipo_calender</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-10  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-10>patterns</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                          \n",
       "                <input type=\"radio\" name=\"select\" id=tab-637-11  onclick=\"switchTab637(this)\">\n",
       "                <label for=tab-637-11>recommendations</label>\n",
       "                \n",
       "                    \t\t\n",
       "            </div>\n",
       "            <div class=\"contents-637\">\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>symbol (required)</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>from_ (required)</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>to (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('company_news', symbol='aapl', from_='2020-04-03', to='2020-05-01')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d6dea2e_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d6dea2e_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d6dea2e_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d6dea2e_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d6dea2e_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >category</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >datetime</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >headline</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >id</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >image</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >related</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row6_col0\" class=\"data row6 col0\" >source</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row7_col0\" class=\"data row7 col0\" >summary</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row7_col1\" class=\"data row7 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row8_col0\" class=\"data row8 col0\" >url</td>\n",
       "                        <td id=\"T_7d6dea2e_35b1_11eb_a3bc_c82a14415709row8_col1\" class=\"data row8 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p>None</p>\n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('countries')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >country</td>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >code2</td>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >code3</td>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >codeNo</td>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >currency</td>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >currencyCode</td>\n",
       "                        <td id=\"T_7d6ee7d0_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p>None</p>\n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('covid19')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d6f71be_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d6f71be_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d6f71be_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d6f71be_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d6f71be_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >state</td>\n",
       "                        <td id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >case</td>\n",
       "                        <td id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >death</td>\n",
       "                        <td id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >updated</td>\n",
       "                        <td id=\"T_7d6f71be_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>symbol (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>limit</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('earnings', symbol='aapl')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >actual</td>\n",
       "                        <td id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >estimate</td>\n",
       "                        <td id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >period</td>\n",
       "                        <td id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >symbol</td>\n",
       "                        <td id=\"T_7d6fcdb2_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>symbol</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>from_</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>to</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>international</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('earnings_calender')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d701740_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d701740_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d701740_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d701740_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d701740_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >date</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >epsActual</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >epsEstimate</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >hour</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >quarter</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >revenueActual</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row6_col0\" class=\"data row6 col0\" >revenueEstimate</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row6_col1\" class=\"data row6 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row7_col0\" class=\"data row7 col0\" >symbol</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row7_col1\" class=\"data row7 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row8_col0\" class=\"data row8 col0\" >year</td>\n",
       "                        <td id=\"T_7d701740_35b1_11eb_a3bc_c82a14415709row8_col1\" class=\"data row8 col1\" >int</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p>None</p>\n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('economic_calender')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d708b26_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d708b26_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d708b26_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d708b26_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d708b26_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >actual</td>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >country</td>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >estimate</td>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >event</td>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >impact</td>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >prev</td>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row6_col0\" class=\"data row6 col0\" >time</td>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row7_col0\" class=\"data row7 col0\" >unit</td>\n",
       "                        <td id=\"T_7d708b26_35b1_11eb_a3bc_c82a14415709row7_col1\" class=\"data row7 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>symbol</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>cik</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>accessNumber</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>form</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>from</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>to</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('filings')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d70efee_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d70efee_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d70efee_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d70efee_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d70efee_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >accessNumber</td>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >symbol</td>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >cik</td>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >form</td>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >filedDate</td>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >acceptedDate</td>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row6_col0\" class=\"data row6 col0\" >reportUrl</td>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row7_col0\" class=\"data row7 col0\" >filingUrl</td>\n",
       "                        <td id=\"T_7d70efee_35b1_11eb_a3bc_c82a14415709row7_col1\" class=\"data row7 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>category (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>minId</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('general_news', category='general')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d7152f4_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d7152f4_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d7152f4_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d7152f4_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d7152f4_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >category</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >datetime</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >headline</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >id</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >image</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >related</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row6_col0\" class=\"data row6 col0\" >source</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row7_col0\" class=\"data row7 col0\" >summary</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row7_col1\" class=\"data row7 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row8_col0\" class=\"data row8 col0\" >url</td>\n",
       "                        <td id=\"T_7d7152f4_35b1_11eb_a3bc_c82a14415709row8_col1\" class=\"data row8 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>from_ (required)</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>to (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('ipo_calender', from_='2020-01-01', to='2020-04-30')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d71bc30_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d71bc30_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d71bc30_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d71bc30_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d71bc30_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >date</td>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >exchange</td>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >name</td>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >numberOfShares</td>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >price</td>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >status</td>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row6_col0\" class=\"data row6 col0\" >symbol</td>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row7_col0\" class=\"data row7 col0\" >totalSharesValue</td>\n",
       "                        <td id=\"T_7d71bc30_35b1_11eb_a3bc_c82a14415709row7_col1\" class=\"data row7 col1\" >float</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>symbol (required)</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>resolution (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('patterns', symbol='aapl', resolution='d')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d7220d0_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d7220d0_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d7220d0_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d7220d0_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d7220d0_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >aprice</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >atime</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >bprice</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >btime</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >cprice</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >ctime</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row6_col0\" class=\"data row6 col0\" >dprice</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row6_col1\" class=\"data row6 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row7_col0\" class=\"data row7 col0\" >dtime</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row7_col1\" class=\"data row7 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row8_col0\" class=\"data row8 col0\" >end_price</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row8_col1\" class=\"data row8 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row9_col0\" class=\"data row9 col0\" >end_time</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row9_col1\" class=\"data row9 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row10\" class=\"row_heading level0 row10\" >10</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row10_col0\" class=\"data row10 col0\" >entry</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row10_col1\" class=\"data row10 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row11\" class=\"row_heading level0 row11\" >11</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row11_col0\" class=\"data row11 col0\" >eprice</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row11_col1\" class=\"data row11 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row12\" class=\"row_heading level0 row12\" >12</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row12_col0\" class=\"data row12 col0\" >etime</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row12_col1\" class=\"data row12 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row13\" class=\"row_heading level0 row13\" >13</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row13_col0\" class=\"data row13 col0\" >mature</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row13_col1\" class=\"data row13 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row14\" class=\"row_heading level0 row14\" >14</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row14_col0\" class=\"data row14 col0\" >patternname</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row14_col1\" class=\"data row14 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row15\" class=\"row_heading level0 row15\" >15</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row15_col0\" class=\"data row15 col0\" >patterntype</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row15_col1\" class=\"data row15 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row16\" class=\"row_heading level0 row16\" >16</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row16_col0\" class=\"data row16 col0\" >profit1</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row16_col1\" class=\"data row16 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row17\" class=\"row_heading level0 row17\" >17</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row17_col0\" class=\"data row17 col0\" >profit2</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row17_col1\" class=\"data row17 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row18\" class=\"row_heading level0 row18\" >18</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row18_col0\" class=\"data row18 col0\" >sortTime</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row18_col1\" class=\"data row18 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row19\" class=\"row_heading level0 row19\" >19</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row19_col0\" class=\"data row19 col0\" >start_price</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row19_col1\" class=\"data row19 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row20\" class=\"row_heading level0 row20\" >20</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row20_col0\" class=\"data row20 col0\" >start_time</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row20_col1\" class=\"data row20 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row21\" class=\"row_heading level0 row21\" >21</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row21_col0\" class=\"data row21 col0\" >status</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row21_col1\" class=\"data row21 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row22\" class=\"row_heading level0 row22\" >22</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row22_col0\" class=\"data row22 col0\" >stoploss</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row22_col1\" class=\"data row22 col1\" >float</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row23\" class=\"row_heading level0 row23\" >23</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row23_col0\" class=\"data row23 col0\" >symbol</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row23_col1\" class=\"data row23 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709level0_row24\" class=\"row_heading level0 row24\" >24</th>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row24_col0\" class=\"data row24 col0\" >terminal</td>\n",
       "                        <td id=\"T_7d7220d0_35b1_11eb_a3bc_c82a14415709row24_col1\" class=\"data row24 col1\" >float</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>symbol (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('finnhub', _auth={'access_token':'cCMHU4M4t7rdt*********vp3whGzFjgIKIm0'}, _concurrency=3)<br>df = await dc.query('recommendations', symbol='aapl')</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_7d736e0e_35b1_11eb_a3bc_c82a14415709 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_7d736e0e_35b1_11eb_a3bc_c82a14415709 td {\n",
       "          font-family: arial;\n",
       "    }    #T_7d736e0e_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d736e0e_35b1_11eb_a3bc_c82a14415709 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_7d736e0e_35b1_11eb_a3bc_c82a14415709 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row0_col0\" class=\"data row0 col0\" >buy</td>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row0_col1\" class=\"data row0 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row1_col0\" class=\"data row1 col0\" >hold</td>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row1_col1\" class=\"data row1 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row2_col0\" class=\"data row2 col0\" >period</td>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row3_col0\" class=\"data row3 col0\" >sell</td>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row3_col1\" class=\"data row3 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row4_col0\" class=\"data row4 col0\" >strongBuy</td>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row4_col1\" class=\"data row4 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row5_col0\" class=\"data row5 col0\" >strongSell</td>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row5_col1\" class=\"data row5 col1\" >int</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row6_col0\" class=\"data row6 col0\" >symbol</td>\n",
       "                        <td id=\"T_7d736e0e_35b1_11eb_a3bc_c82a14415709row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "            </div>\n",
       "        </div>\n",
       "    </body>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "info('finnhub')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Connector.query\n",
    "The query method downloads the website data and displays it in a Dataframe. The parameters must meet the requirements as indicated in connector.info for the operation to run.\n",
    "\n",
    "When the data is received from the server, it will either be in a JSON or XML format. The connector reformats the data in pandas Dataframe for the convenience of downstream operations.\n",
    "\n",
    "As an example, let's try to fetch some data on Stock Fundamentals, Stock Estimates, Technical Analysis, Economic Data and more!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Stock Fundamentals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>category</th>\n",
       "      <th>datetime</th>\n",
       "      <th>headline</th>\n",
       "      <th>id</th>\n",
       "      <th>image</th>\n",
       "      <th>related</th>\n",
       "      <th>source</th>\n",
       "      <th>summary</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1607030879</td>\n",
       "      <td>Bitcoin a ‘Potential Store of Value’ That’s Ve...</td>\n",
       "      <td>5700144</td>\n",
       "      <td>https://static.coindesk.com/wp-content/uploads...</td>\n",
       "      <td></td>\n",
       "      <td>CoinDesk</td>\n",
       "      <td>Many investors aspire to hold bitcoin as a sto...</td>\n",
       "      <td>https://www.coindesk.com/bitcoin-potential-sto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1607030315</td>\n",
       "      <td>Analysts say surging Bitcoin whale inflows hei...</td>\n",
       "      <td>5700024</td>\n",
       "      <td>https://res.cloudinary.com/whirlpooldata/image...</td>\n",
       "      <td></td>\n",
       "      <td>Cointelegraph</td>\n",
       "      <td>Bitcoin whale inflows are increasing as the pr...</td>\n",
       "      <td>https://cointelegraph.com/news/analysts-say-su...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1607028463</td>\n",
       "      <td>SEC Makes FinHub a Stand-Alone Office</td>\n",
       "      <td>5699915</td>\n",
       "      <td>https://static.coindesk.com/wp-content/uploads...</td>\n",
       "      <td></td>\n",
       "      <td>CoinDesk</td>\n",
       "      <td>The reorganization strengthens FinHub's hand i...</td>\n",
       "      <td>https://www.coindesk.com/sec-finhub-office</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1607026785</td>\n",
       "      <td>OKEx’s Trading Volumes and Tether Reserve Plun...</td>\n",
       "      <td>5699916</td>\n",
       "      <td>https://static.coindesk.com/wp-content/uploads...</td>\n",
       "      <td></td>\n",
       "      <td>CoinDesk</td>\n",
       "      <td>A sharp drop in OKEx’s trading volume and stab...</td>\n",
       "      <td>https://www.coindesk.com/okex-volume-tether-re...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1607025999</td>\n",
       "      <td>SEC's fintech wing leaves the nest, becoming s...</td>\n",
       "      <td>5699806</td>\n",
       "      <td>https://res.cloudinary.com/whirlpooldata/image...</td>\n",
       "      <td></td>\n",
       "      <td>Cointelegraph</td>\n",
       "      <td>FinHub will have new independence and responsi...</td>\n",
       "      <td>https://cointelegraph.com/news/sec-s-fintech-w...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1606905052</td>\n",
       "      <td>Dusk Network Takes ‘Around 10%’ Stake in Dutch...</td>\n",
       "      <td>5692379</td>\n",
       "      <td>https://static.coindesk.com/wp-content/uploads...</td>\n",
       "      <td></td>\n",
       "      <td>CoinDesk</td>\n",
       "      <td>Security token platform Dusk Network has becom...</td>\n",
       "      <td>https://www.coindesk.com/blockchain-startup-du...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1606903496</td>\n",
       "      <td>Russian central bank opposes ruble-pegged stab...</td>\n",
       "      <td>5692276</td>\n",
       "      <td>https://res.cloudinary.com/whirlpooldata/image...</td>\n",
       "      <td></td>\n",
       "      <td>Cointelegraph</td>\n",
       "      <td>Russia wants to follow China’s approach of ban...</td>\n",
       "      <td>https://cointelegraph.com/news/russian-central...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1606901560</td>\n",
       "      <td>Crypto.com Secures Australian Financial Servic...</td>\n",
       "      <td>5692166</td>\n",
       "      <td>https://static.coindesk.com/wp-content/uploads...</td>\n",
       "      <td></td>\n",
       "      <td>CoinDesk</td>\n",
       "      <td>Crypto.com has secured an  Australian Financia...</td>\n",
       "      <td>https://www.coindesk.com/crypto-com-secures-au...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1606899792</td>\n",
       "      <td>NYDIG raises $150 million for two Bitcoin inve...</td>\n",
       "      <td>5692062</td>\n",
       "      <td>https://res.cloudinary.com/whirlpooldata/image...</td>\n",
       "      <td></td>\n",
       "      <td>Cointelegraph</td>\n",
       "      <td>Bitcoin is becoming an increasingly “instituti...</td>\n",
       "      <td>https://cointelegraph.com/news/nydig-raises-15...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>crypto</td>\n",
       "      <td>1606899600</td>\n",
       "      <td>Bitcoin hitting $200K by December 2021 is now ...</td>\n",
       "      <td>5692063</td>\n",
       "      <td>https://res.cloudinary.com/whirlpooldata/image...</td>\n",
       "      <td></td>\n",
       "      <td>Cointelegraph</td>\n",
       "      <td>BTC/USD is more likely to reach $300,000 in a ...</td>\n",
       "      <td>https://cointelegraph.com/news/bitcoin-hitting...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   category    datetime                                           headline  \\\n",
       "0    crypto  1607030879  Bitcoin a ‘Potential Store of Value’ That’s Ve...   \n",
       "1    crypto  1607030315  Analysts say surging Bitcoin whale inflows hei...   \n",
       "2    crypto  1607028463              SEC Makes FinHub a Stand-Alone Office   \n",
       "3    crypto  1607026785  OKEx’s Trading Volumes and Tether Reserve Plun...   \n",
       "4    crypto  1607025999  SEC's fintech wing leaves the nest, becoming s...   \n",
       "..      ...         ...                                                ...   \n",
       "95   crypto  1606905052  Dusk Network Takes ‘Around 10%’ Stake in Dutch...   \n",
       "96   crypto  1606903496  Russian central bank opposes ruble-pegged stab...   \n",
       "97   crypto  1606901560  Crypto.com Secures Australian Financial Servic...   \n",
       "98   crypto  1606899792  NYDIG raises $150 million for two Bitcoin inve...   \n",
       "99   crypto  1606899600  Bitcoin hitting $200K by December 2021 is now ...   \n",
       "\n",
       "         id                                              image related  \\\n",
       "0   5700144  https://static.coindesk.com/wp-content/uploads...           \n",
       "1   5700024  https://res.cloudinary.com/whirlpooldata/image...           \n",
       "2   5699915  https://static.coindesk.com/wp-content/uploads...           \n",
       "3   5699916  https://static.coindesk.com/wp-content/uploads...           \n",
       "4   5699806  https://res.cloudinary.com/whirlpooldata/image...           \n",
       "..      ...                                                ...     ...   \n",
       "95  5692379  https://static.coindesk.com/wp-content/uploads...           \n",
       "96  5692276  https://res.cloudinary.com/whirlpooldata/image...           \n",
       "97  5692166  https://static.coindesk.com/wp-content/uploads...           \n",
       "98  5692062  https://res.cloudinary.com/whirlpooldata/image...           \n",
       "99  5692063  https://res.cloudinary.com/whirlpooldata/image...           \n",
       "\n",
       "           source                                            summary  \\\n",
       "0        CoinDesk  Many investors aspire to hold bitcoin as a sto...   \n",
       "1   Cointelegraph  Bitcoin whale inflows are increasing as the pr...   \n",
       "2        CoinDesk  The reorganization strengthens FinHub's hand i...   \n",
       "3        CoinDesk  A sharp drop in OKEx’s trading volume and stab...   \n",
       "4   Cointelegraph  FinHub will have new independence and responsi...   \n",
       "..            ...                                                ...   \n",
       "95       CoinDesk  Security token platform Dusk Network has becom...   \n",
       "96  Cointelegraph  Russia wants to follow China’s approach of ban...   \n",
       "97       CoinDesk  Crypto.com has secured an  Australian Financia...   \n",
       "98  Cointelegraph  Bitcoin is becoming an increasingly “instituti...   \n",
       "99  Cointelegraph  BTC/USD is more likely to reach $300,000 in a ...   \n",
       "\n",
       "                                                  url  \n",
       "0   https://www.coindesk.com/bitcoin-potential-sto...  \n",
       "1   https://cointelegraph.com/news/analysts-say-su...  \n",
       "2          https://www.coindesk.com/sec-finhub-office  \n",
       "3   https://www.coindesk.com/okex-volume-tether-re...  \n",
       "4   https://cointelegraph.com/news/sec-s-fintech-w...  \n",
       "..                                                ...  \n",
       "95  https://www.coindesk.com/blockchain-startup-du...  \n",
       "96  https://cointelegraph.com/news/russian-central...  \n",
       "97  https://www.coindesk.com/crypto-com-secures-au...  \n",
       "98  https://cointelegraph.com/news/nydig-raises-15...  \n",
       "99  https://cointelegraph.com/news/bitcoin-hitting...  \n",
       "\n",
       "[100 rows x 9 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# category = general/forex/crypto/merger\n",
    "df = await dc.query('general_news', category='crypto')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>category</th>\n",
       "      <th>datetime</th>\n",
       "      <th>headline</th>\n",
       "      <th>id</th>\n",
       "      <th>image</th>\n",
       "      <th>related</th>\n",
       "      <th>source</th>\n",
       "      <th>summary</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>company</td>\n",
       "      <td>1588377600</td>\n",
       "      <td>WhatsApp Suddenly Gets Powerful New Security B...</td>\n",
       "      <td>691320</td>\n",
       "      <td>https://thumbor.forbes.com/thumbor/fit-in/1200...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>https://www.forbes.com</td>\n",
       "      <td>WhatsApp has been seriously boosted this week—...</td>\n",
       "      <td>https://www.forbes.com/sites/zakdoffman/2020/0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>company</td>\n",
       "      <td>1588377600</td>\n",
       "      <td>2020 iPhone Alert: Apple’s New Price Changes R...</td>\n",
       "      <td>691319</td>\n",
       "      <td>https://thumbor.forbes.com/thumbor/fit-in/1200...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>https://www.forbes.com</td>\n",
       "      <td>Apple's most exciting iPhone 12 change is a sh...</td>\n",
       "      <td>https://www.forbes.com/sites/gordonkelly/2020/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>company</td>\n",
       "      <td>1588377600</td>\n",
       "      <td>Forget Google—Huawei Plans A Killer New Update...</td>\n",
       "      <td>691318</td>\n",
       "      <td>https://thumbor.forbes.com/thumbor/fit-in/1200...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>https://www.forbes.com</td>\n",
       "      <td>Is this enough to make you switch away from Go...</td>\n",
       "      <td>https://www.forbes.com/sites/zakdoffman/2020/0...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>company</td>\n",
       "      <td>1588377600</td>\n",
       "      <td>Apple Watch Series 6 Leak Details 5 Great Inno...</td>\n",
       "      <td>687591</td>\n",
       "      <td>https://thumbor.forbes.com/thumbor/fit-in/1200...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>https://www.forbes.com</td>\n",
       "      <td>A leak, confirmed by one of the hottest tipste...</td>\n",
       "      <td>https://www.forbes.com/sites/davidphelan/2020/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>company</td>\n",
       "      <td>1588377600</td>\n",
       "      <td>Market Slides More Than 2% to Begin May</td>\n",
       "      <td>666265</td>\n",
       "      <td>https://i-invdn-com.akamaized.net/redesign/ima...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>investing</td>\n",
       "      <td>Stocks Analysis by Zacks Investment Research c...</td>\n",
       "      <td>https://www.investing.com/analysis/market-slid...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>company</td>\n",
       "      <td>1588333335</td>\n",
       "      <td>BUZZ-U.S. STOCKS ON THE MOVE-Medigus Ltd, West...</td>\n",
       "      <td>61097129</td>\n",
       "      <td>https://www.nasdaq.com/sites/acquia.prod/files...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>Nasdaq</td>\n",
       "      <td>A compilation of the most active stocks on U.S...</td>\n",
       "      <td>https://www.nasdaq.com/articles/buzz-u.s.-stoc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>company news</td>\n",
       "      <td>1588333335</td>\n",
       "      <td>BUZZ-U.S. STOCKS ON THE MOVE-Medigus Ltd, West...</td>\n",
       "      <td>59361466</td>\n",
       "      <td>https://www.nasdaq.com/sites/acquia.prod/files...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>Nasdaq</td>\n",
       "      <td>A compilation of the most active stocks on U.S...</td>\n",
       "      <td>https://www.nasdaq.com//articles/buzz-u.s.-sto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>company</td>\n",
       "      <td>1588333261</td>\n",
       "      <td>U.S. Stock Futures Sink After Tech Giants Repo...</td>\n",
       "      <td>24814</td>\n",
       "      <td>https://img.zonebourse.com/reuters/2016-12-22T...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>marketscreener</td>\n",
       "      <td></td>\n",
       "      <td>https://www.marketscreener.com/news/U-S-Stock-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>company news</td>\n",
       "      <td>1588333173</td>\n",
       "      <td>Take Buffett’s Advice: 5 Vanguard Funds to Buy</td>\n",
       "      <td>629385</td>\n",
       "      <td>https://investorplace.com/wp-content/uploads/2...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>INVESTORPLACE</td>\n",
       "      <td>Warren Buffett believes index funds are the wa...</td>\n",
       "      <td>https://investorplace.com/2020/05/5-vanguard-f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>company</td>\n",
       "      <td>1588333111</td>\n",
       "      <td>3 Takeaways from Apple’s Strong Q2 Earnings Re...</td>\n",
       "      <td>5786251</td>\n",
       "      <td>https://marketrealist.imgix.net/uploads/2020/0...</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>https://marketrealist.com</td>\n",
       "      <td>Apple’s earnings report delivers good news for...</td>\n",
       "      <td>https://marketrealist.com/2020/05/3-takeaways-...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         category    datetime  \\\n",
       "0         company  1588377600   \n",
       "1         company  1588377600   \n",
       "2         company  1588377600   \n",
       "3         company  1588377600   \n",
       "4         company  1588377600   \n",
       "..            ...         ...   \n",
       "195       company  1588333335   \n",
       "196  company news  1588333335   \n",
       "197       company  1588333261   \n",
       "198  company news  1588333173   \n",
       "199       company  1588333111   \n",
       "\n",
       "                                              headline        id  \\\n",
       "0    WhatsApp Suddenly Gets Powerful New Security B...    691320   \n",
       "1    2020 iPhone Alert: Apple’s New Price Changes R...    691319   \n",
       "2    Forget Google—Huawei Plans A Killer New Update...    691318   \n",
       "3    Apple Watch Series 6 Leak Details 5 Great Inno...    687591   \n",
       "4              Market Slides More Than 2% to Begin May    666265   \n",
       "..                                                 ...       ...   \n",
       "195  BUZZ-U.S. STOCKS ON THE MOVE-Medigus Ltd, West...  61097129   \n",
       "196  BUZZ-U.S. STOCKS ON THE MOVE-Medigus Ltd, West...  59361466   \n",
       "197  U.S. Stock Futures Sink After Tech Giants Repo...     24814   \n",
       "198     Take Buffett’s Advice: 5 Vanguard Funds to Buy    629385   \n",
       "199  3 Takeaways from Apple’s Strong Q2 Earnings Re...   5786251   \n",
       "\n",
       "                                                 image related  \\\n",
       "0    https://thumbor.forbes.com/thumbor/fit-in/1200...    AAPL   \n",
       "1    https://thumbor.forbes.com/thumbor/fit-in/1200...    AAPL   \n",
       "2    https://thumbor.forbes.com/thumbor/fit-in/1200...    AAPL   \n",
       "3    https://thumbor.forbes.com/thumbor/fit-in/1200...    AAPL   \n",
       "4    https://i-invdn-com.akamaized.net/redesign/ima...    AAPL   \n",
       "..                                                 ...     ...   \n",
       "195  https://www.nasdaq.com/sites/acquia.prod/files...    AAPL   \n",
       "196  https://www.nasdaq.com/sites/acquia.prod/files...    AAPL   \n",
       "197  https://img.zonebourse.com/reuters/2016-12-22T...    AAPL   \n",
       "198  https://investorplace.com/wp-content/uploads/2...    AAPL   \n",
       "199  https://marketrealist.imgix.net/uploads/2020/0...    AAPL   \n",
       "\n",
       "                        source  \\\n",
       "0       https://www.forbes.com   \n",
       "1       https://www.forbes.com   \n",
       "2       https://www.forbes.com   \n",
       "3       https://www.forbes.com   \n",
       "4                    investing   \n",
       "..                         ...   \n",
       "195                     Nasdaq   \n",
       "196                     Nasdaq   \n",
       "197             marketscreener   \n",
       "198              INVESTORPLACE   \n",
       "199  https://marketrealist.com   \n",
       "\n",
       "                                               summary  \\\n",
       "0    WhatsApp has been seriously boosted this week—...   \n",
       "1    Apple's most exciting iPhone 12 change is a sh...   \n",
       "2    Is this enough to make you switch away from Go...   \n",
       "3    A leak, confirmed by one of the hottest tipste...   \n",
       "4    Stocks Analysis by Zacks Investment Research c...   \n",
       "..                                                 ...   \n",
       "195  A compilation of the most active stocks on U.S...   \n",
       "196  A compilation of the most active stocks on U.S...   \n",
       "197                                                      \n",
       "198  Warren Buffett believes index funds are the wa...   \n",
       "199  Apple’s earnings report delivers good news for...   \n",
       "\n",
       "                                                   url  \n",
       "0    https://www.forbes.com/sites/zakdoffman/2020/0...  \n",
       "1    https://www.forbes.com/sites/gordonkelly/2020/...  \n",
       "2    https://www.forbes.com/sites/zakdoffman/2020/0...  \n",
       "3    https://www.forbes.com/sites/davidphelan/2020/...  \n",
       "4    https://www.investing.com/analysis/market-slid...  \n",
       "..                                                 ...  \n",
       "195  https://www.nasdaq.com/articles/buzz-u.s.-stoc...  \n",
       "196  https://www.nasdaq.com//articles/buzz-u.s.-sto...  \n",
       "197  https://www.marketscreener.com/news/U-S-Stock-...  \n",
       "198  https://investorplace.com/2020/05/5-vanguard-f...  \n",
       "199  https://marketrealist.com/2020/05/3-takeaways-...  \n",
       "\n",
       "[200 rows x 9 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('company_news', symbol='AAPL', from_='2020-04-01', to='2020-05-01')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>accessNumber</th>\n",
       "      <th>symbol</th>\n",
       "      <th>cik</th>\n",
       "      <th>form</th>\n",
       "      <th>filedDate</th>\n",
       "      <th>acceptedDate</th>\n",
       "      <th>reportUrl</th>\n",
       "      <th>filingUrl</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0000320193-20-000101</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>4</td>\n",
       "      <td>2020-11-17 00:00:00</td>\n",
       "      <td>2020-11-17 18:30:43</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0000320193-20-000099</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>4</td>\n",
       "      <td>2020-11-05 00:00:00</td>\n",
       "      <td>2020-11-05 18:30:55</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0000320193-20-000094</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>8-K</td>\n",
       "      <td>2020-10-29 00:00:00</td>\n",
       "      <td>2020-10-29 16:30:32</td>\n",
       "      <td>https://www.sec.gov/ix?doc=/Archives/edgar/dat...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0000320193-20-000090</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>4</td>\n",
       "      <td>2020-10-19 00:00:00</td>\n",
       "      <td>2020-10-19 18:32:33</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0000320193-20-000089</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>4</td>\n",
       "      <td>2020-10-19 00:00:00</td>\n",
       "      <td>2020-10-19 18:30:33</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>0001181431-14-032543</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>4</td>\n",
       "      <td>2014-09-23 00:00:00</td>\n",
       "      <td>2014-09-23 18:34:20</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>0001181431-14-032241</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>4</td>\n",
       "      <td>2014-09-17 00:00:00</td>\n",
       "      <td>2014-09-17 18:33:17</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>0001193125-14-277193</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>8-K</td>\n",
       "      <td>2014-07-23 00:00:00</td>\n",
       "      <td>2014-07-23 16:44:58</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>0001193125-14-277160</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>10-Q</td>\n",
       "      <td>2014-07-23 00:00:00</td>\n",
       "      <td>2014-07-23 16:32:48</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>0001193125-14-275598</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>320193</td>\n",
       "      <td>8-K</td>\n",
       "      <td>2014-07-22 00:00:00</td>\n",
       "      <td>2014-07-22 16:31:08</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "      <td>https://www.sec.gov/Archives/edgar/data/320193...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>250 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             accessNumber symbol     cik  form            filedDate  \\\n",
       "0    0000320193-20-000101   AAPL  320193     4  2020-11-17 00:00:00   \n",
       "1    0000320193-20-000099   AAPL  320193     4  2020-11-05 00:00:00   \n",
       "2    0000320193-20-000094   AAPL  320193   8-K  2020-10-29 00:00:00   \n",
       "3    0000320193-20-000090   AAPL  320193     4  2020-10-19 00:00:00   \n",
       "4    0000320193-20-000089   AAPL  320193     4  2020-10-19 00:00:00   \n",
       "..                    ...    ...     ...   ...                  ...   \n",
       "245  0001181431-14-032543   AAPL  320193     4  2014-09-23 00:00:00   \n",
       "246  0001181431-14-032241   AAPL  320193     4  2014-09-17 00:00:00   \n",
       "247  0001193125-14-277193   AAPL  320193   8-K  2014-07-23 00:00:00   \n",
       "248  0001193125-14-277160   AAPL  320193  10-Q  2014-07-23 00:00:00   \n",
       "249  0001193125-14-275598   AAPL  320193   8-K  2014-07-22 00:00:00   \n",
       "\n",
       "            acceptedDate                                          reportUrl  \\\n",
       "0    2020-11-17 18:30:43  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "1    2020-11-05 18:30:55  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "2    2020-10-29 16:30:32  https://www.sec.gov/ix?doc=/Archives/edgar/dat...   \n",
       "3    2020-10-19 18:32:33  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "4    2020-10-19 18:30:33  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "..                   ...                                                ...   \n",
       "245  2014-09-23 18:34:20  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "246  2014-09-17 18:33:17  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "247  2014-07-23 16:44:58  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "248  2014-07-23 16:32:48  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "249  2014-07-22 16:31:08  https://www.sec.gov/Archives/edgar/data/320193...   \n",
       "\n",
       "                                             filingUrl  \n",
       "0    https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "1    https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "2    https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "3    https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "4    https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "..                                                 ...  \n",
       "245  https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "246  https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "247  https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "248  https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "249  https://www.sec.gov/Archives/edgar/data/320193...  \n",
       "\n",
       "[250 rows x 8 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('filings', symbol='AAPL')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>name</th>\n",
       "      <th>numberOfShares</th>\n",
       "      <th>price</th>\n",
       "      <th>status</th>\n",
       "      <th>symbol</th>\n",
       "      <th>totalSharesValue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-30</td>\n",
       "      <td>None</td>\n",
       "      <td>Vontier Corp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-30</td>\n",
       "      <td>NYSE</td>\n",
       "      <td>Fortress Value Acquisition Corp.</td>\n",
       "      <td>30000000.0</td>\n",
       "      <td>10.00</td>\n",
       "      <td>priced</td>\n",
       "      <td>FVACU</td>\n",
       "      <td>300000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-04-28</td>\n",
       "      <td>NYSE</td>\n",
       "      <td>Social Capital Hedosophia Holdings Corp. II</td>\n",
       "      <td>36000000.0</td>\n",
       "      <td>10.00</td>\n",
       "      <td>priced</td>\n",
       "      <td>IPOBU</td>\n",
       "      <td>360000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-04-24</td>\n",
       "      <td>None</td>\n",
       "      <td>Father Time, Inc.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-04-24</td>\n",
       "      <td>None</td>\n",
       "      <td>SeqLL, Inc.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>2020-01-08</td>\n",
       "      <td>None</td>\n",
       "      <td>Ardent Health Partners, LLC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2020-01-06</td>\n",
       "      <td>None</td>\n",
       "      <td>Arcutis Biotherapeutics, Inc.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>filed</td>\n",
       "      <td>ARQT</td>\n",
       "      <td>159375000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>None</td>\n",
       "      <td>Black Diamond Therapeutics, Inc.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>filed</td>\n",
       "      <td>BDTX</td>\n",
       "      <td>201140004.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>None</td>\n",
       "      <td>1life Healthcare Inc</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>filed</td>\n",
       "      <td>ONEM</td>\n",
       "      <td>245000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>2020-01-02</td>\n",
       "      <td>None</td>\n",
       "      <td>AVADIM HEALTH, INC.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>filed</td>\n",
       "      <td>AHI</td>\n",
       "      <td>92000000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>78 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          date exchange                                         name  \\\n",
       "0   2020-04-30     None                                 Vontier Corp   \n",
       "1   2020-04-30     NYSE             Fortress Value Acquisition Corp.   \n",
       "2   2020-04-28     NYSE  Social Capital Hedosophia Holdings Corp. II   \n",
       "3   2020-04-24     None                            Father Time, Inc.   \n",
       "4   2020-04-24     None                                  SeqLL, Inc.   \n",
       "..         ...      ...                                          ...   \n",
       "73  2020-01-08     None                  Ardent Health Partners, LLC   \n",
       "74  2020-01-06     None                Arcutis Biotherapeutics, Inc.   \n",
       "75  2020-01-03     None             Black Diamond Therapeutics, Inc.   \n",
       "76  2020-01-03     None                         1life Healthcare Inc   \n",
       "77  2020-01-02     None                          AVADIM HEALTH, INC.   \n",
       "\n",
       "    numberOfShares  price     status symbol  totalSharesValue  \n",
       "0              NaN   None  withdrawn   None               NaN  \n",
       "1       30000000.0  10.00     priced  FVACU       300000000.0  \n",
       "2       36000000.0  10.00     priced  IPOBU       360000000.0  \n",
       "3              NaN   None  withdrawn   None               NaN  \n",
       "4              NaN   None  withdrawn   None               NaN  \n",
       "..             ...    ...        ...    ...               ...  \n",
       "73             NaN   None  withdrawn   None               NaN  \n",
       "74             NaN   None      filed   ARQT       159375000.0  \n",
       "75             NaN   None      filed   BDTX       201140004.0  \n",
       "76             NaN   None      filed   ONEM       245000000.0  \n",
       "77             NaN   None      filed    AHI        92000000.0  \n",
       "\n",
       "[78 rows x 8 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('ipo_calender', from_='2020-01-01', to='2020-04-30')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Stock Estimates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>buy</th>\n",
       "      <th>hold</th>\n",
       "      <th>period</th>\n",
       "      <th>sell</th>\n",
       "      <th>strongBuy</th>\n",
       "      <th>strongSell</th>\n",
       "      <th>symbol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>24</td>\n",
       "      <td>7</td>\n",
       "      <td>2020-11-01</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18</td>\n",
       "      <td>11</td>\n",
       "      <td>2020-10-01</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>19</td>\n",
       "      <td>10</td>\n",
       "      <td>2020-09-01</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2020-08-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2020-07-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2020-06-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>20</td>\n",
       "      <td>8</td>\n",
       "      <td>2020-05-01</td>\n",
       "      <td>3</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2020-04-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2020-02-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2020-01-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2019-10-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>13</td>\n",
       "      <td>19</td>\n",
       "      <td>2019-07-01</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>2019-06-01</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>2019-05-01</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>2019-04-01</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>14</td>\n",
       "      <td>18</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>2018-12-01</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>2018-11-01</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>16</td>\n",
       "      <td>15</td>\n",
       "      <td>2018-10-01</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>2018-09-01</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>16</td>\n",
       "      <td>15</td>\n",
       "      <td>2018-08-01</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2018-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>17</td>\n",
       "      <td>16</td>\n",
       "      <td>2018-06-01</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>19</td>\n",
       "      <td>15</td>\n",
       "      <td>2018-05-01</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>19</td>\n",
       "      <td>14</td>\n",
       "      <td>2018-04-01</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    buy  hold      period  sell  strongBuy  strongSell symbol\n",
       "0    24     7  2020-11-01     0         13           0   AAPL\n",
       "1    18    11  2020-10-01     1         13           2   AAPL\n",
       "2    19    10  2020-09-01     2         13           2   AAPL\n",
       "3    13    19  2020-08-01     3         15           0   AAPL\n",
       "4    13    19  2020-07-01     3         15           0   AAPL\n",
       "5    13    19  2020-06-01     3         15           0   AAPL\n",
       "6    20     8  2020-05-01     3         14           0   AAPL\n",
       "7    13    19  2020-04-01     3         15           0   AAPL\n",
       "8    13    19  2020-03-01     3         15           0   AAPL\n",
       "9    13    19  2020-02-01     3         15           0   AAPL\n",
       "10   13    19  2020-01-01     3         15           0   AAPL\n",
       "11   13    19  2019-12-01     3         15           0   AAPL\n",
       "12   13    19  2019-11-01     3         15           0   AAPL\n",
       "13   13    19  2019-10-01     3         15           0   AAPL\n",
       "14   13    19  2019-09-01     3         15           0   AAPL\n",
       "15   13    19  2019-08-01     3         15           0   AAPL\n",
       "16   13    19  2019-07-01     3         15           0   AAPL\n",
       "17   10    20  2019-06-01     2         15           0   AAPL\n",
       "18   10    22  2019-05-01     1         15           0   AAPL\n",
       "19   10    22  2019-04-01     1         15           0   AAPL\n",
       "20   10    22  2019-03-01     1         15           0   AAPL\n",
       "21   10    22  2019-02-01     1         15           0   AAPL\n",
       "22   14    18  2019-01-01     0         17           0   AAPL\n",
       "23   14    17  2018-12-01     0         16           0   AAPL\n",
       "24   16    14  2018-11-01     0         19           0   AAPL\n",
       "25   16    15  2018-10-01     0         17           0   AAPL\n",
       "26   15    15  2018-09-01     0         17           0   AAPL\n",
       "27   16    15  2018-08-01     0         15           0   AAPL\n",
       "28   16    16  2018-07-01     0         15           0   AAPL\n",
       "29   17    16  2018-06-01     0         15           0   AAPL\n",
       "30   19    15  2018-05-01     0         15           0   AAPL\n",
       "31   19    14  2018-04-01     0         13           0   AAPL"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('recommendations', symbol='AAPL')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>actual</th>\n",
       "      <th>estimate</th>\n",
       "      <th>period</th>\n",
       "      <th>symbol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.73</td>\n",
       "      <td>0.7140</td>\n",
       "      <td>2020-09-30</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.64</td>\n",
       "      <td>0.5202</td>\n",
       "      <td>2020-06-30</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.64</td>\n",
       "      <td>0.5712</td>\n",
       "      <td>2020-03-31</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.25</td>\n",
       "      <td>1.1628</td>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>AAPL</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   actual  estimate      period symbol\n",
       "0    0.73    0.7140  2020-09-30   AAPL\n",
       "1    0.64    0.5202  2020-06-30   AAPL\n",
       "2    0.64    0.5712  2020-03-31   AAPL\n",
       "3    1.25    1.1628  2019-12-31   AAPL"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('earnings', symbol='AAPL')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>epsActual</th>\n",
       "      <th>epsEstimate</th>\n",
       "      <th>hour</th>\n",
       "      <th>quarter</th>\n",
       "      <th>revenueActual</th>\n",
       "      <th>revenueEstimate</th>\n",
       "      <th>symbol</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-03-13</td>\n",
       "      <td>-0.030</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>amc</td>\n",
       "      <td>4</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>THCB</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-03-13</td>\n",
       "      <td>0.073</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>amc</td>\n",
       "      <td>4</td>\n",
       "      <td>5.216000e+06</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>PER</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-03-13</td>\n",
       "      <td>-0.010</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>amc</td>\n",
       "      <td>4</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>GMHI</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-03-13</td>\n",
       "      <td>-0.270</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>amc</td>\n",
       "      <td>4</td>\n",
       "      <td>1.110000e+05</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>CDZI</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-03-13</td>\n",
       "      <td>0.230</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>amc</td>\n",
       "      <td>4</td>\n",
       "      <td>1.036000e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>PICO</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>2020-03-12</td>\n",
       "      <td>5.250</td>\n",
       "      <td>5.928546</td>\n",
       "      <td>amc</td>\n",
       "      <td>1</td>\n",
       "      <td>5.858000e+09</td>\n",
       "      <td>6.090000e+09</td>\n",
       "      <td>AVGO</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>2020-03-12</td>\n",
       "      <td>-0.100</td>\n",
       "      <td>0.051000</td>\n",
       "      <td>amc</td>\n",
       "      <td>4</td>\n",
       "      <td>2.161000e+07</td>\n",
       "      <td>1.742755e+07</td>\n",
       "      <td>ASUR</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>2020-03-12</td>\n",
       "      <td>-0.040</td>\n",
       "      <td>0.056355</td>\n",
       "      <td>amc</td>\n",
       "      <td>4</td>\n",
       "      <td>2.519910e+08</td>\n",
       "      <td>2.670566e+08</td>\n",
       "      <td>AGRO</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>2020-03-12</td>\n",
       "      <td>0.090</td>\n",
       "      <td>0.079815</td>\n",
       "      <td>amc</td>\n",
       "      <td>4</td>\n",
       "      <td>6.097000e+07</td>\n",
       "      <td>6.215860e+07</td>\n",
       "      <td>AGFS</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>2020-03-12</td>\n",
       "      <td>2.270</td>\n",
       "      <td>2.691739</td>\n",
       "      <td>amc</td>\n",
       "      <td>1</td>\n",
       "      <td>3.091000e+09</td>\n",
       "      <td>3.095750e+09</td>\n",
       "      <td>ADBE</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>220 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  epsActual  epsEstimate hour  quarter  revenueActual  \\\n",
       "0    2020-03-13     -0.030     0.000000  amc        4   0.000000e+00   \n",
       "1    2020-03-13      0.073     0.000000  amc        4   5.216000e+06   \n",
       "2    2020-03-13     -0.010     0.000000  amc        4   0.000000e+00   \n",
       "3    2020-03-13     -0.270     0.000000  amc        4   1.110000e+05   \n",
       "4    2020-03-13      0.230     0.000000  amc        4   1.036000e+07   \n",
       "..          ...        ...          ...  ...      ...            ...   \n",
       "215  2020-03-12      5.250     5.928546  amc        1   5.858000e+09   \n",
       "216  2020-03-12     -0.100     0.051000  amc        4   2.161000e+07   \n",
       "217  2020-03-12     -0.040     0.056355  amc        4   2.519910e+08   \n",
       "218  2020-03-12      0.090     0.079815  amc        4   6.097000e+07   \n",
       "219  2020-03-12      2.270     2.691739  amc        1   3.091000e+09   \n",
       "\n",
       "     revenueEstimate symbol  year  \n",
       "0       0.000000e+00   THCB  2019  \n",
       "1       0.000000e+00    PER  2019  \n",
       "2       0.000000e+00   GMHI  2019  \n",
       "3       0.000000e+00   CDZI  2019  \n",
       "4       0.000000e+00   PICO  2019  \n",
       "..               ...    ...   ...  \n",
       "215     6.090000e+09   AVGO  2020  \n",
       "216     1.742755e+07   ASUR  2019  \n",
       "217     2.670566e+08   AGRO  2019  \n",
       "218     6.215860e+07   AGFS  2019  \n",
       "219     3.095750e+09   ADBE  2020  \n",
       "\n",
       "[220 rows x 9 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('earnings_calender', from_=\"2020-03-12\", to=\"2020-03-15\")\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Technical Analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>aprice</th>\n",
       "      <th>atime</th>\n",
       "      <th>bprice</th>\n",
       "      <th>btime</th>\n",
       "      <th>cprice</th>\n",
       "      <th>ctime</th>\n",
       "      <th>dprice</th>\n",
       "      <th>dtime</th>\n",
       "      <th>end_price</th>\n",
       "      <th>end_time</th>\n",
       "      <th>...</th>\n",
       "      <th>patterntype</th>\n",
       "      <th>profit1</th>\n",
       "      <th>profit2</th>\n",
       "      <th>sortTime</th>\n",
       "      <th>start_price</th>\n",
       "      <th>start_time</th>\n",
       "      <th>status</th>\n",
       "      <th>stoploss</th>\n",
       "      <th>symbol</th>\n",
       "      <th>terminal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>103.099998</td>\n",
       "      <td>1600646400</td>\n",
       "      <td>112.860001</td>\n",
       "      <td>1600732800</td>\n",
       "      <td>105.000000</td>\n",
       "      <td>1600905600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>112.860001</td>\n",
       "      <td>1.601251e+09</td>\n",
       "      <td>...</td>\n",
       "      <td>bullish</td>\n",
       "      <td>122.620003</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1601251200</td>\n",
       "      <td>112.860001</td>\n",
       "      <td>1.600214e+09</td>\n",
       "      <td>successful</td>\n",
       "      <td>102.123998</td>\n",
       "      <td>AAPL.US</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>99.250000</td>\n",
       "      <td>1595289600</td>\n",
       "      <td>91.341139</td>\n",
       "      <td>1595289600</td>\n",
       "      <td>95.581434</td>\n",
       "      <td>1595894400</td>\n",
       "      <td>87.672573</td>\n",
       "      <td>1595894400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>bullish</td>\n",
       "      <td>103.490295</td>\n",
       "      <td>125.581434</td>\n",
       "      <td>1595894400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>success</td>\n",
       "      <td>87.672573</td>\n",
       "      <td>AAPL.US</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       aprice       atime      bprice       btime      cprice       ctime  \\\n",
       "0  103.099998  1600646400  112.860001  1600732800  105.000000  1600905600   \n",
       "1   99.250000  1595289600   91.341139  1595289600   95.581434  1595894400   \n",
       "\n",
       "      dprice       dtime   end_price      end_time  ...  patterntype  \\\n",
       "0   0.000000           0  112.860001  1.601251e+09  ...      bullish   \n",
       "1  87.672573  1595894400         NaN           NaN  ...      bullish   \n",
       "\n",
       "      profit1     profit2    sortTime start_price    start_time      status  \\\n",
       "0  122.620003    0.000000  1601251200  112.860001  1.600214e+09  successful   \n",
       "1  103.490295  125.581434  1595894400         NaN           NaN     success   \n",
       "\n",
       "     stoploss   symbol  terminal  \n",
       "0  102.123998  AAPL.US       0.0  \n",
       "1   87.672573  AAPL.US       0.0  \n",
       "\n",
       "[2 rows x 25 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('patterns', symbol='AAPL', resolution='D')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Alternative Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>case</th>\n",
       "      <th>death</th>\n",
       "      <th>updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>New York</td>\n",
       "      <td>660798</td>\n",
       "      <td>34294</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>New Jersey</td>\n",
       "      <td>344387</td>\n",
       "      <td>17215</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>California</td>\n",
       "      <td>1246276</td>\n",
       "      <td>19320</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>395453</td>\n",
       "      <td>9761</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Florida</td>\n",
       "      <td>1008166</td>\n",
       "      <td>18682</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Wuhan Evacuee</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Northern Mariana Islands</td>\n",
       "      <td>31</td>\n",
       "      <td>2</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>US Military</td>\n",
       "      <td>117736</td>\n",
       "      <td>129</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Federal Bureau of Prisons</td>\n",
       "      <td>28895</td>\n",
       "      <td>147</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Veteran Affair</td>\n",
       "      <td>112894</td>\n",
       "      <td>5022</td>\n",
       "      <td>2020-12-02 13:11:21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        state     case  death              updated\n",
       "0                    New York   660798  34294  2020-12-02 13:11:21\n",
       "1                  New Jersey   344387  17215  2020-12-02 13:11:21\n",
       "2                  California  1246276  19320  2020-12-02 13:11:21\n",
       "3                    Michigan   395453   9761  2020-12-02 13:11:21\n",
       "4                     Florida  1008166  18682  2020-12-02 13:11:21\n",
       "..                        ...      ...    ...                  ...\n",
       "57              Wuhan Evacuee        4      0  2020-12-02 13:11:21\n",
       "58   Northern Mariana Islands       31      2  2020-12-02 13:11:21\n",
       "59                US Military   117736    129  2020-12-02 13:11:21\n",
       "60  Federal Bureau of Prisons    28895    147  2020-12-02 13:11:21\n",
       "61             Veteran Affair   112894   5022  2020-12-02 13:11:21\n",
       "\n",
       "[62 rows x 4 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('covid19')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Economic Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>country</th>\n",
       "      <th>code2</th>\n",
       "      <th>code3</th>\n",
       "      <th>codeNo</th>\n",
       "      <th>currency</th>\n",
       "      <th>currencyCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Nauru</td>\n",
       "      <td>NR</td>\n",
       "      <td>NRU</td>\n",
       "      <td>520</td>\n",
       "      <td>Australian Dollars</td>\n",
       "      <td>AUD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Saint Martin (French part)</td>\n",
       "      <td>MF</td>\n",
       "      <td>MAF</td>\n",
       "      <td>663</td>\n",
       "      <td>Netherlands Antillean guilder</td>\n",
       "      <td>ANG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>GE</td>\n",
       "      <td>GEO</td>\n",
       "      <td>268</td>\n",
       "      <td>Lari</td>\n",
       "      <td>GEL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Antarctica</td>\n",
       "      <td>AQ</td>\n",
       "      <td>ATA</td>\n",
       "      <td>10</td>\n",
       "      <td>Antarctican dollar</td>\n",
       "      <td>AQD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>VC</td>\n",
       "      <td>VCT</td>\n",
       "      <td>670</td>\n",
       "      <td>East Caribbean Dollar</td>\n",
       "      <td>XCD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>Cook Islands (the)</td>\n",
       "      <td>CK</td>\n",
       "      <td>COK</td>\n",
       "      <td>184</td>\n",
       "      <td>New Zealand Dollars</td>\n",
       "      <td>NZD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>PER</td>\n",
       "      <td>604</td>\n",
       "      <td>Nuevo Sol</td>\n",
       "      <td>PEN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>Martinique</td>\n",
       "      <td>MQ</td>\n",
       "      <td>MTQ</td>\n",
       "      <td>474</td>\n",
       "      <td>Euros</td>\n",
       "      <td>EUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>Senegal</td>\n",
       "      <td>SN</td>\n",
       "      <td>SEN</td>\n",
       "      <td>686</td>\n",
       "      <td>CFA Franc BCEAO</td>\n",
       "      <td>XOF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>Montenegro</td>\n",
       "      <td>ME</td>\n",
       "      <td>MNE</td>\n",
       "      <td>499</td>\n",
       "      <td>Euro</td>\n",
       "      <td>EUR</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>249 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              country code2 code3 codeNo  \\\n",
       "0                               Nauru    NR   NRU    520   \n",
       "1          Saint Martin (French part)    MF   MAF    663   \n",
       "2                             Georgia    GE   GEO    268   \n",
       "3                          Antarctica    AQ   ATA     10   \n",
       "4    Saint Vincent and the Grenadines    VC   VCT    670   \n",
       "..                                ...   ...   ...    ...   \n",
       "244                Cook Islands (the)    CK   COK    184   \n",
       "245                              Peru    PE   PER    604   \n",
       "246                        Martinique    MQ   MTQ    474   \n",
       "247                           Senegal    SN   SEN    686   \n",
       "248                        Montenegro    ME   MNE    499   \n",
       "\n",
       "                          currency currencyCode  \n",
       "0               Australian Dollars          AUD  \n",
       "1    Netherlands Antillean guilder          ANG  \n",
       "2                             Lari          GEL  \n",
       "3               Antarctican dollar          AQD  \n",
       "4            East Caribbean Dollar          XCD  \n",
       "..                             ...          ...  \n",
       "244            New Zealand Dollars          NZD  \n",
       "245                      Nuevo Sol          PEN  \n",
       "246                          Euros          EUR  \n",
       "247                CFA Franc BCEAO          XOF  \n",
       "248                           Euro          EUR  \n",
       "\n",
       "[249 rows x 6 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('countries')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>actual</th>\n",
       "      <th>country</th>\n",
       "      <th>estimate</th>\n",
       "      <th>event</th>\n",
       "      <th>impact</th>\n",
       "      <th>prev</th>\n",
       "      <th>time</th>\n",
       "      <th>unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-6.90</td>\n",
       "      <td>NZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NBNZ Business Outlook</td>\n",
       "      <td>low</td>\n",
       "      <td>-15.70</td>\n",
       "      <td>2020-11-30 00:00:00</td>\n",
       "      <td>Net balance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9.10</td>\n",
       "      <td>NZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NBNZ Own Activity</td>\n",
       "      <td>low</td>\n",
       "      <td>4.70</td>\n",
       "      <td>2020-11-30 00:00:00</td>\n",
       "      <td>Net balance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.30</td>\n",
       "      <td>AU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Housing Credit</td>\n",
       "      <td>low</td>\n",
       "      <td>0.40</td>\n",
       "      <td>2020-11-30 00:30:00</td>\n",
       "      <td>%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>AU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Private Sector Credit</td>\n",
       "      <td>low</td>\n",
       "      <td>0.10</td>\n",
       "      <td>2020-11-30 00:30:00</td>\n",
       "      <td>%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2412.33</td>\n",
       "      <td>AU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Broad Money</td>\n",
       "      <td>low</td>\n",
       "      <td>2398.72</td>\n",
       "      <td>2020-11-30 00:30:00</td>\n",
       "      <td>AUD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>NaN</td>\n",
       "      <td>US</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4W Bill Auc - BTC</td>\n",
       "      <td>low</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-12-10 20:00:00</td>\n",
       "      <td>Ratio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>NaN</td>\n",
       "      <td>US</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4W Bill Auc - HR</td>\n",
       "      <td>low</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-12-10 20:00:00</td>\n",
       "      <td>%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>NaN</td>\n",
       "      <td>US</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4W Bill Auc - TA</td>\n",
       "      <td>low</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-12-10 20:00:00</td>\n",
       "      <td>USD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manufacturing PMI</td>\n",
       "      <td>low</td>\n",
       "      <td>51.70</td>\n",
       "      <td>2020-12-10 21:30:00</td>\n",
       "      <td>Index (diffusion)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Food Price Index</td>\n",
       "      <td>low</td>\n",
       "      <td>-0.70</td>\n",
       "      <td>2020-12-10 21:45:00</td>\n",
       "      <td>%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>453 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      actual country  estimate                  event impact     prev  \\\n",
       "0      -6.90      NZ       NaN  NBNZ Business Outlook    low   -15.70   \n",
       "1       9.10      NZ       NaN      NBNZ Own Activity    low     4.70   \n",
       "2       0.30      AU       NaN         Housing Credit    low     0.40   \n",
       "3       0.00      AU       NaN  Private Sector Credit    low     0.10   \n",
       "4    2412.33      AU       NaN            Broad Money    low  2398.72   \n",
       "..       ...     ...       ...                    ...    ...      ...   \n",
       "448      NaN      US       NaN      4W Bill Auc - BTC    low      NaN   \n",
       "449      NaN      US       NaN       4W Bill Auc - HR    low      NaN   \n",
       "450      NaN      US       NaN       4W Bill Auc - TA    low      NaN   \n",
       "451      NaN      NZ       NaN      Manufacturing PMI    low    51.70   \n",
       "452      NaN      NZ       NaN       Food Price Index    low    -0.70   \n",
       "\n",
       "                    time               unit  \n",
       "0    2020-11-30 00:00:00        Net balance  \n",
       "1    2020-11-30 00:00:00        Net balance  \n",
       "2    2020-11-30 00:30:00                  %  \n",
       "3    2020-11-30 00:30:00                  %  \n",
       "4    2020-11-30 00:30:00                AUD  \n",
       "..                   ...                ...  \n",
       "448  2020-12-10 20:00:00              Ratio  \n",
       "449  2020-12-10 20:00:00                  %  \n",
       "450  2020-12-10 20:00:00                USD  \n",
       "451  2020-12-10 21:30:00  Index (diffusion)  \n",
       "452  2020-12-10 21:45:00                  %  \n",
       "\n",
       "[453 rows x 8 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await dc.query('economic_calender')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# That's all for now. \n",
    "If you are interested in writing your own configuration file or modify an existing one, refer to the [Configuration Files](https://github.com/sfu-db/DataConnectorConfigs>)."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
